Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | |
EquipmentID (FK) | The fixed asset number assigned by the retailer for this particular piece of equipment. | ID_EQ | Identity | integer | Equipment(AS_EQ) |
ManufacturerName | The name of the MANUFACTURER of the WORKSTATION. Currently most MANUFACTURERs simply assembly the components and place their badge on the device. | NM_WS_MF | Name | varchar(40) | |
TerminalModelNumber | The model number of the WORKSTATION. | NM_MDL_WS_TML | Name | varchar(40) | |
TerminalStatusCode | The status code of the WORKSTATION, i.e. active, closed, off-line, etc. | SC_TML_WS | Code2Status | char(2) | |
TillCount | The number of tills that can be supported through the one WORKSTATION. In most instances each WORKSTATION has one. In cases such as duty free stores or where the retailer wants to maintain operator accountability there may be two. | QU_TL_WS | QuantityShortCount | decimal(3,0) | |
TypeCode | A code to denote the type or use of WORKSTATION, such as POS register, goods receipt terminal. | TY_WS | Code4 | char(4) | |
TrainingModeFlag | A flag to denote whether the WORKSTATION is in normal operation or training mode. In the latter none of the history accumulators are updated. | FL_MOD_TRG | Flag | integer | |
OutsideFlag | A flag denoting that this Workstation is positioned outside the store (Perhaps at a FuelingPosition in the Forecourt business segment) | FL_WS_OTSD | Flag | integer | |
DeviceAddress | The device address of this WORKSTATION | NM_ADS_DVC | Name | varchar(40) | |
WorkstationGroupID (FK) | A unqiue system assigned identifier for a set of Workstations with similar resource access control permissions. | ID_WSGP | Identity | integer | WorkstationGroup(CO_WSGP) |